UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/MY5elkHD1UYRvG/gPyWtA71CKCWazGVFj4prv+vYYk='
WHERE
key_id = '2417bf1914cf170a7201320395d06d07771cb77e31ad24cdd44a77161f70aae1'
AND (
token = '/MY5elkHD1UYRvG/gPyWtA71CKCWazGVFj4prv+vYYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)