UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TcjgDbB/k9zgQ140nqcpocQdfzJuB7tpDP135BsTSsw='
WHERE
key_id = 'ed48c73f653cd390a7b41502de5253f910ee771e9daff49901a1645119cae0a6'
AND (
token = 'TcjgDbB/k9zgQ140nqcpocQdfzJuB7tpDP135BsTSsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)