UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vB72YLYCqXiCIz0uaHwX2FadKtUBu583bN2j236/fwA='
WHERE
key_id = '572cf7cf12496e9c1f3e16118f87019e5dc81872508a4d4e9893d9041c29128b'
AND (
token = 'vB72YLYCqXiCIz0uaHwX2FadKtUBu583bN2j236/fwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)