UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HJredQUTxMvoGOP2uVNrM/HihL7a5xtR/tyjTMbjczI='
WHERE
key_id = '7d6767ed51935665941867efa128efb940dc770d2503dad85e340644cfb917d8'
AND (
token = 'HJredQUTxMvoGOP2uVNrM/HihL7a5xtR/tyjTMbjczI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)