UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jPgRKQ5WXSjItWHN39Ajcv5GnQkGett1qPVDP+/obQ='
WHERE
key_id = 'bdbdcd2fe3c70cdced4bf1b674579c109877262b8e5ee711b795089fd85823d5'
AND (
token = '4jPgRKQ5WXSjItWHN39Ajcv5GnQkGett1qPVDP+/obQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)