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