UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xztmji3TDVOcqSJCawfNSPo46llPmJtCg7pxJyMLRTs='
WHERE
key_id = '56a7caebd057c5743931fae92f9bc41a1a91abe7e33115e093569f1b678084dc'
AND (
token = 'Xztmji3TDVOcqSJCawfNSPo46llPmJtCg7pxJyMLRTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)