UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DTKM0heg+xJxDmsruewmUmvJo+tQ0fKY3WXbb+vytdY='
WHERE
key_id = '3789ddd07f75b93a16758bb569ecfef1c917b68d042d22be70d2d6fcd20b521e'
AND (
token = 'DTKM0heg+xJxDmsruewmUmvJo+tQ0fKY3WXbb+vytdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)