UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0hpyVhFaAPiF0gT4sF3g498RbJtJei6Yl1O4o5tgevw='
WHERE
key_id = 'a1146f0f7aeec9ef0a043464f6528b49fa46e9b2ad33102932983a3e6a367512'
AND (
token = '0hpyVhFaAPiF0gT4sF3g498RbJtJei6Yl1O4o5tgevw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)