UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZyh2vLjoWMIGMNe3oVJp13CIV9yZYNKII03Ck6bcQo='
WHERE
key_id = 'e7f2d7180d30a365792c4cd574febf091d841a16d5a3ffabeaa5b4f78a20bb24'
AND (
token = 'yZyh2vLjoWMIGMNe3oVJp13CIV9yZYNKII03Ck6bcQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)