UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'btCttXLINq1e2AU5iJmaYL7hOPIDQEtdIb1fL8uNydM='
WHERE
key_id = '542300ddbd382e14eb1003906a37e8b04720b13cebdc0f40e5943b0a902c8938'
AND (
token = 'btCttXLINq1e2AU5iJmaYL7hOPIDQEtdIb1fL8uNydM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)