UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LcQ2WcIojGuKBL/MlcR1maxFNKuWwYN7Sgdn5yx3HsE='
WHERE
key_id = '1fd8bb282496eeeeda2e59d8962ba15f6c329593c204c541043bc8a223d88ea6'
AND (
token = 'LcQ2WcIojGuKBL/MlcR1maxFNKuWwYN7Sgdn5yx3HsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)