UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aZTkFOsu28jUIxBK2CAz5uOmgAuPfSHvTn9jfrLAqc8='
WHERE
key_id = '2008ef6bb73102c799c8909bbacc25037b7e22cb7e33bfae774e5830ca771a4a'
AND (
token = 'aZTkFOsu28jUIxBK2CAz5uOmgAuPfSHvTn9jfrLAqc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)