UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTh4r8tDll4KcZPipAeN6mCUs6t84Y8H3k9fHc8YGlM='
WHERE
key_id = 'd619024580816277c2f459993d6c3a5b5a402cbe23c58f2153d3c2d473bb6846'
AND (
token = 'sTh4r8tDll4KcZPipAeN6mCUs6t84Y8H3k9fHc8YGlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)