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