UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A7wMnUwnnPezFeuNgT6+6gyT3pST46ZxZMrq2kF/7HE='
WHERE
key_id = '0b161911ff7e88cf8260c740fc7dd1c7352bcc596e8259e0a6ed733b72bf58d8'
AND (
token = 'A7wMnUwnnPezFeuNgT6+6gyT3pST46ZxZMrq2kF/7HE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)