UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/mAsMUoyoUwxl20r4zsbINHWI4V13TxgnF6Y+IafKOI='
WHERE
key_id = '4493aa857b6c77190a0cba173e966cca81e6ed97b7a7289f59cedaf6a72816da'
AND (
token = '/mAsMUoyoUwxl20r4zsbINHWI4V13TxgnF6Y+IafKOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)