UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rZIUgoNCoBPO8uSeWbbkn94mJ2FCLchBExo/hU1v0BI='
WHERE
key_id = '5a42a9703529562febf64391147396799c728c953e64287ea9d6e67f939402a3'
AND (
token = 'rZIUgoNCoBPO8uSeWbbkn94mJ2FCLchBExo/hU1v0BI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)