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