UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '41qFYKKBNUzAj5dxY451tJeG0QLJeEcijRE/MhP4ho8='
WHERE
key_id = '946c8c5f912aa097de3ab9d0fcb4b2b1a59e629dad71a08ff03541837d2fe008'
AND (
token = '41qFYKKBNUzAj5dxY451tJeG0QLJeEcijRE/MhP4ho8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)