UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '38yrwlU9Uu7J7NOfRBepnlsAN1gtS/vG5SYWFZzPbl4='
WHERE
key_id = 'd8d43757f8ab9b298e10796a54f7c836eeb644e907d57e9c900965ce2ba4887b'
AND (
token = '38yrwlU9Uu7J7NOfRBepnlsAN1gtS/vG5SYWFZzPbl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)