UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTFG228uVX6Fl+9Y4nPB7rc5VlEVFUNW//s4QWrjkEs='
WHERE
key_id = 'd303d15048eb7dc03d13ddcd67962afde233e8153b5f460b56951c3148b66c02'
AND (
token = 'CTFG228uVX6Fl+9Y4nPB7rc5VlEVFUNW//s4QWrjkEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)