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