UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E/3HqN0Uppu54tg02oJD/lsZqb4gy7pLSs+wLb/4bbg='
WHERE
key_id = 'db8ce1a27e1edd1d9714b4f2b3f1ff5c82affa0c147a111b2c5d6cf199a784f3'
AND (
token = 'E/3HqN0Uppu54tg02oJD/lsZqb4gy7pLSs+wLb/4bbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)