UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hsQjzpb5+KbDG9Pi6QGOvznojsecRecs0onLW6ZprTA='
WHERE
key_id = '1cd7855cbc21306310810d83e380a74ae33402cc5c4eba916d30c2dcd4109460'
AND (
token = 'hsQjzpb5+KbDG9Pi6QGOvznojsecRecs0onLW6ZprTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)