UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cEi1WWV1qYSxR5x2hY+yBVGFlCIM99Yor8m+98T7dk='
WHERE
key_id = '171a7e2e10bbd6aea431e30036203494ce77a44dfeb7e054153468786616bdda'
AND (
token = '7cEi1WWV1qYSxR5x2hY+yBVGFlCIM99Yor8m+98T7dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)